﻿CREATE TABLE [dbo].[AngajamentLegalDetaliu] (
    [IDALDetaliu] INT             IDENTITY (1, 1) NOT NULL,
    [IDAL]        INT             NOT NULL,
    [IDJurnal]    INT             NOT NULL,
    [ArtAl]       VARCHAR (40)    NOT NULL,
    [Suma]        DECIMAL (18, 2) NOT NULL,
    [Clasif]      VARCHAR (100)   NULL,
    CONSTRAINT [PK_AngajamentLegalDetaliu] PRIMARY KEY CLUSTERED ([IDALDetaliu] ASC),
    CONSTRAINT [FK_AngajamentLegalDetaliu_AngajamentLegal] FOREIGN KEY ([IDAL]) REFERENCES [dbo].[AngajamentLegal] ([IDAL]),
    CONSTRAINT [FK_AngajamentLegalDetaliu_Jurnale] FOREIGN KEY ([IDJurnal]) REFERENCES [dbo].[Jurnale] ([IDJurnal])
);

